package com.example.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.vo.CmsmeVo;
import com.example.entity.yifei.Cmsmd;
import com.example.entity.yifei.Cmsme;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 *
 * @Author: LiangPanDeng
 * @Date: 2023/12/18/16:56
 * @Description:    部门信息档   Mapper
 */
@Mapper
public interface CmsmeMapper extends BaseMapper<Cmsme> {

    List<CmsmeVo> selectCmsmeVoList();

    /**
     * 根据 部门编号 获取部门信息详情
     * @param ME001
     * @return
     */
    @Select("select * from CMSME where ME001 = #{ME001}")
    Cmsme getByME001(String ME001);

    @Select("select ME001,ME002 from CMSME")
    List<Cmsme> getAll();

    @Select("select * from CMSMD where MD001 = #{MD001}")
    Cmsmd getByMD001(String MD001);
}
